EMT Practice Test

1. Question Content...

A. Choice A

B. Choice B

C. Choice C

D. Choice D

E. Choice E

Was this helpful? Upvote!

Question List

Question1: David, a Lead Data engineer with XYZ company looking out to improve query performance & oth-er benefits while working with Tables, Regular Views, MVs and Cached Results.
Which one of the following does not shows key similarities and differences between tables, regular views, cached query results, and materialized views while choosing any of them by David?

Question2: The smaller the average depth, the better clustered the table is with regards to the specified column?

Question3: Which one is not the Core benefits of micro-partitioning

Question4: Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and independent data storage?

Question5: Changing the retention period for your account or individual objects changes the value for all lower-level objects that do not have a retention period explicitly set?

Question6: While creating External function, Which Database object required with at least ACCOUNTAD-MIN privileges?

Question7: By default, a newly-created Custom role is not assigned to any user, nor granted to any other role?

Question8: If using a JavaScript UDF in a masking policy, Data Engineer needs to ensure the data type of the column, UDF, and masking policy match irrespective of case-sensitivity?

Question9: Charles, A Lead Data engineer, with ACCOUNTADMIN role wants to configure the time travel for one of the Schema's object. He setup the MIN_DATA_RETENTION_TIME_IN_DAYS pa-rameter with Value 79 at account level but he figured out that DA-TA_RETENTION_TIME_IN_DAYS is already set with value 81 at account level. What would be the effective minimum data retention period for an object?

Question10: Dominic, a Data Engineer wants to resume the pipe named stalepipe3 which got stale after 14 days. To do the same, he called the SYSTEM$PIPE_FORCE_RESUME function select sys-tem$pipe_force_resume('snowmydb.mysnowschema.stalepipe3','staleness_check_override'); Let's say If the pipe is resumed 16 days after it was paused, what will happened to the event notifi-cation that were received on the first and second days after the pipe was paused?

Question11: Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks rather than resuming each task individually (using ALTER TASK ... RESUME)?

Question12: Mark the Correct Statements for the VALIDATION_MODE option used by Data Engineer for Da-ta loading operations in his/her COPY INTO <table> command:

Question13: Mark the Incorrect Statements with respect to types of streams supported by Snowflake?

Question14: Which Role inherits the privileges of the USERADMIN role via the system role hierarchy?

Question15: Which of the following System keeps the following characteristics?
a. It will keep in it all the raw data.
b. Generally, the users of it is data scientists and data developers.
c. Flat architecture
d. Highly agile

Question17: Select the incorrect statement while working with warehouses?

Question18: SYSTEM$CLUSTERING_INFORMATION functions returns clustering information, including average clustering depth, for a table based on one or more columns in the table. The function returns a JSON object containing average_overlaps name/value pairs. Does High average_overlaps indicates well organized Clustering?

Question19: Select the Incorrect statement about External Functions in SnowFlake?

Question20: How Data Engineer can do Monitoring of Files which are Staged Internally during Continuous data pipelines loading process? [Select all that apply]

Question21: Data Engineer is using existing pipe that automates data loads using event notifications, later he figured out the needs to modify pipe properties. For the same, He decided to recreate the pipe as best practice. He followed the below steps for the same.
1. Query the SYSTEM$PIPE_STATUS function and verify that the pipe execution state is RUN-NING.
2. Recreate the pipe (using CREATE OR REPLACE PIPE).
3. Query the SYSTEM$PIPE_STATUS function and verify that the pipe execution state is RUN-NING.
Which are the Missing recommended steps while Recreating Pipes for Automated Data Loads?

Question22: Ryan, a Data Engineer, accidently drop the Share named SF_SHARE which results in immediate access revoke for all the consumers (i.e., accounts who have created a database from that SF_SHARE). What action he can take to recover the dropped Share?

Question23: The following CREATE DATABASE command creates a clone of a database snowmy_db i.e.
Create database pods_db clone snowmy_db
before (statement => '7e5d0cb9-005e-94e6-b058-k8f5b37c5725');
What are possible reason of failing cloning operation for this database?

Question24: Mark a Data Engineer, looking to implement streams on local views & want to use change tracking metadata for one of its Data Loading use case. Please select the incorrect understanding points of Mark with respect to usage of Streams on Views?

Question25: For enabling non-ACCOUNTADMIN Roles to Perform Data Sharing Tasks, which two glob-al/account privileges snowflake provide?

Question26: Select the Correct statements with regard to using Federated authentication/SSO?

Question27: Which of the below concepts/functions helps while implementing advanced Column-level Security?

Question28: If you need to connect to Snowflake using a BI tool or technology, which of the following BI tools and technologies are known to provide native connectivity to Snowflake?

Question29: Which is the non-supportable JavaScript UDF data types?

Question30: Harry using Snowflake Enterprise Edition & decided to scale in/out the Cluster in automatic mode. He needs to configure some warehouses as multi cluster mode and some among them in Standard mode as per needs.
If Harry is using Snowflake Enterprise Edition (or a higher edition), all his warehouses should be configured as multi-cluster warehouses only.

Question31: Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario?

Question32: While creating even Secure UDF, snowflake recommended to use randomized identifiers (e.g. gen-erated by UUID_STRING) instead of sequence-generated values?

Question33: Steven created the task, what additional privileges required by Steven on the task so that he can suspend or resume the tasks?

Question34: PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove par-titions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?

Question35: Find out the odd one out:

Question36: As part of Table Designing, Data Engineer added a timestamp column that inserts the current timestamp as the default value as records are loaded into a table. The intent is to capture the time when eachrecord was loaded into the table; however, the timestamps are earlier than the LOAD_TIME column values returned by COPY_HISTORY view (Account Usage). What could be reason of this issue?

Question37: Data Engineer is looking out to delete staged files automatically/periodically when the data is suc-cessfully loaded into tables by the Snowpipe. For achieving the same, which options/command is best suited: [Select 2]

Question38: Mark the incorrect statement when Data Engineer implement Automating Continuous Data Loading Using Cloud Messaging?

Question39: Streams cannot be created to query change data on which of the following objects? [Select All that Apply]

Question40: Data Engineer try to load data from external stage using Snowpipe & later find out that some Set of Files Not Loaded. To debug the issue, she used COPY_HISTORY function & cross verified that its output indicates a subset of files was not loaded. What is possible reason of arising this situation in both REST API call and Auto-Ingest methods? [Select 2]

Question41: Ryan, a Data Engineer, wants to improve the performance of large, complex queries against large data sets. He decided to Scale up underlying warehouse/cluster. What is correct Snowflake consid-eration while scaling up so that he can achieve better performance results? [Select all that apply]

Question42: Mark the correct statements about Cache?

Question43: Which are the Cloud Platforms that Support Calling an External Function?

Question44: Streams cannot be created to query change data on which of the following objects? [Select All that Apply]

Question45: Bob, a Lead Data Engineer is looking out to get the function definition & queried below statement to check if this function is secure enough to use in his script or not.
select is_secure from information_schema.functions where function_name = 'JOHNFUNCTION'; From the query output he is sure that, Function is secure UDF, what are the way provided by snow-flake to get the function definition of secure UDF?

Question46: Data Engineer decided to call the public REST endpoints to load data and retrieve load history re-ports. Which of the following REST endpoints and a Snowflake Information Schema table function for viewing your load history can be used by her? [Select All that apply]

Question47: Let us say you have List of 50 Source files, which needs to be loaded into Snowflake internal stage. All these Source system files are already Brotli-compressed files. Which statement is correct with respect to Compression of Staged Files?

Question48: Which are supported Programming Languages for Creating UDTFs?

Question49: You can execute zero, one, or more transactions inside a stored procedure?

Question50: Which UDF programming language is not supported with Snowflake Secure Data Sharing feature?

Question51: For SQL UDFs, The invoker of the function need not have access to the objects referenced in the function definition, but only needs the privilege to use the function?

Question52: The COPY command supports several options for loading data files from a stage i.e.
I. By path
II. Specifying a list of specific files to load.
III. Using pattern matching to identify specific files by pattern.
IV. Organize files into logical paths that reflect a scheduling pattern.
Of the aforesaid options for identifying/specifying data files to load from a stage, which option in general is the fastest & best considerate?

Question53: Data Engineer, ran the below clustering depth analysis function:
select system$clustering_depth('TPCH_CUSTOMERS', '(C1, C6)', 'C9 = 30'); on TPCH_CUSTOMERS table, will return which of the following?

Question54: Mark the incorrect statement in case Data engineer using the COPY INTO <table> command to load data from files into Snowflake tables?

Question55: Snowflake does not treat the inner transaction as nested; instead, the inner transaction is a separate transaction.
What is term used to call these Transaction?

Question56: Which property can be used with ALTER USER command to temporarily disable MFA for the user so that they can log in?